문제
https://www.hackerrank.com/challenges/weather-observation-station-6/problem?isFullScreen=true
Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.
ID int YES NULL
CITY varchar(21) YES NULL
STATE varchar(2) YES NULL
LAT_N decimal(10,0) YES NULL
LONG_W decimal(10,0) YES NULL
풀이
모음으로 시작하는 city 이름의 리스트를 "중복없이" 가져와야함.
SELECT DISTINCT city FROM station
WHERE UPPER(LEFT(`CITY`, 1)) IN ('A', 'E', 'I', 'O', 'U');